package com.dailyblue.project.smbms.alibaba.address.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dailyblue.project.smbms.alibaba.commons.bean.Address;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface AddressMapper extends BaseMapper<Address> {
    @Select("select userId from smbms_address where id=#{id}")
    Integer findUserIdByAddressId(int id);
    @Select("select contact,addressDesc,tel from smbms_address where id=#{id}")
    Address findByAddressId(int id);

}
